This Shiny Apps tries to show the relationship between the Mexico´s public revenue and the number of workers who are enrolled at IMSS. Theoretically, there is a directly proportional relationship between them:the more enrolled workers at IMSS, more public revenue the state catches.

In Database section, users can access directly to the database to know how it looks like. As well, users can order the data and decide how many entries they want to be displayed.

In Data Visualization section, users can create some graphics from the available variables(features) on the database.They must choose a variable for the x axis and other one for y axis using the input windows displayed. Moreover, if users want to deflate the public revenue(ingresos), as the theory says, they must choose the base year to do it and the app will do the operation automatically. In this case, users can use the deflated variable to creat a graphic as well.

 ggplotly( ggplot(data, aes(x= fecha, y= ingreso ))+
                    geom_line(aes(group=1), colour="blue")+ theme_classic()  )

Finally, in Data Model section, the shiny app will display a regression model outcome between deflated public revenue and number of workers. This regression model tests out what the theory says: the more enrolled workers at IMSS, the more public revenue the government catches.

• The shiny app is available a https://ibg93.shinyapps.io/jh_task/

• All the project and documentation is available at